﻿use [clz]
-- =============================================
-- Author:		luohr
-- Description:	  添加表 ApproveStatus
-- =============================================
if exists (select 1
            from  sysobjects
           where  id = object_id('ApproveStatus')
            and   type = 'U')
DROP TABLE [dbo].[ApproveStatus]

/*==============================================================*/
/* Table: ApproveStatus                                         */
/*==============================================================*/
create table ApproveStatus (
   ApproveStatusID      int                  identity,
   ApproveStatusName    nvarchar(50)         not null,
   constraint PK_APPROVESTATUS primary key (ApproveStatusID)
)

SET IDENTITY_INSERT [dbo].ApproveStatus ON
INSERT [dbo].[ApproveStatus] ([ApproveStatusID], [ApproveStatusName]) VALUES (1, N'未审核')
INSERT [dbo].[ApproveStatus] ([ApproveStatusID], [ApproveStatusName]) VALUES (2, N'审核通过')
INSERT [dbo].[ApproveStatus] ([ApproveStatusID], [ApproveStatusName]) VALUES (3, N'审核未通过')
SET IDENTITY_INSERT [dbo].ApproveStatus OFF
